php mysql SELECT

[owelowe]

I have a problem with extracting information from a mysql database, I want to search the database using a number like to, but in the database the rows can have several numbers like for example:

name jord
first 234




SELECT * FROM database WHERE jord =2";


can I search the rows for individual numbers eventhou there are more than one number in the row?

[Utech22]

SELECT * FROM database WHERE jord LIKE "%2";

Read through this: http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html

[kaykays]

jord = 2 will select only value 2

jord LIKE "%2" will select any number with 2 as last digit

jord LIKE "%2%" will select any number with 2 at any position


SELECT * FROM database WHERE jord LIKE "%2%";

[owelowe]

Worked thanks alot!!!