SELECT problem 2

[JuRo]

hi 2 all!
can i SELECT information from a mysql without knowing the whole information in a field?

lets say the data in table "table", field "field" is "a, b, c". i want to SELECT the data with

SELECT * from table WHERE field = X

the SELECT command should show the data whether i replace X by a, b or c ....

i am using mysql and php. i hope this described my problem, if not please tell me!

i am looking forward to your suggestions

JuRo

 

[mweinstock]

If I understand you correctly, "Field" is a string, and you want to be able to select based on a substring? Try the following:

SELECT * from table WHERE field LIKE "%X%"

Where X is what you want to find within the field. For example,


TABLE - BOOKS
FIELDS - ISBN, TITLE, PRICE
DATA:
ISBN TITLE PRICE
01012 MySQL For Dummies 10.50
12373 PHP and MySQL Development 37.25
01297 PHP Web Applications 15.95

Soething like:

Select * from BOOKS where TITLE like "%MySQL%"

will bring back the two books that include MySQL in the title.
--
How can you be in two places at once when you're not anywhere at all?

 

[JuRo]

@mweinstock

thanx.
works like a charm ...

JuRo

 

[sleipnir214]

mweinstock,

JuRo obviously found your post helpful, but he must have overlooked voting your post a star.

So I'll give you one. ______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[mweinstock]

Thanks! --
How can you be in two places at once when you're not anywhere at all?