Select from table where queried value is contained in a field

[bunner_bob]

Not sure if that's the right way to phrase it, but anyway...

Trying to find all results in a table where there is a particular character in a particular field.

So I might have the following entries:

Feature: black spots
Breeds: 123

Feature: long tail
Breeds: 12

Feature: friendly
Breeds: 345

How do I retrieve all records in which Breed "3" is represented? Is there some mysql_query code to tell if something contains something? I only know = and !=

Excuse my ignorance (and I'm supposed to be a 'senior' member! Ha!)

• Bob

[drew010]

you can try something like:

$query = "SELECT * FROM table WHERE breeds LIKE '%3%'";

the % symbol is a wildcard and represents any character any amount of times.. so for example that query will return values where breeds is:
345
135
123
3
23
13
31.
etc...

good luck with it.

[bunner_bob]

That's perfect - thanks.

Now that I've 'used' it it should stick in my brain...

• Bob