MySQL Query WHERE With Wildcard

Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » MySQL Query WHERE With Wildcard

MySQL Query WHERE With Wildcard

Author:

Message:

L. Coyote
Senior Member

Captain Obvious

Posts: 981
Reputation: 49
39 / Male

Joined: Aug 2004
Status: Away

RE: MySQL Query WHERE With Wildcard

quote:
Originally posted by leito.gt
Thank you for your response, well the type of the column is VARCHAR, and numbers are stored there.

Read my edit.

To use wildcards you must use LIKE.

column LIKE '%data%'

edit again: I didn't remember this at first

This post was edited on 01-09-2005 at 02:50 AM by L. Coyote.

Hack, hack, hack!
Finally became a Systems Analyst! :spam:

Messages In This Thread

MySQL Query WHERE With Wildcard - by leito on 01-09-2005 at 02:40 AM

RE: MySQL Query WHERE With Wildcard - by L. Coyote on 01-09-2005 at 02:44 AM

RE: MySQL Query WHERE With Wildcard - by leito on 01-09-2005 at 02:46 AM

RE: MySQL Query WHERE With Wildcard - by L. Coyote on 01-09-2005 at 02:50 AM

RE: MySQL Query WHERE With Wildcard - by leito on 01-09-2005 at 02:53 AM

Forum Rules:
You cannot post new threads You cannot post replies You cannot post attachments You can edit your posts	HTML is Off myCode is On Smilies are On [img] Code is On