[Resolved] MySQL Reads.......

[samgeorge]

$query_OtherTeams = "SELECT DBteam, TeamName, TeamNameS FROM whatteam WHERE 

..........

i need it to say Where Its Doesn't contain Mens or Ladies

.............

tried != '%Mens%' That fails and so does != 'Mens%' any ideas?

[devinemke]

use NOT LIKE

SELECT [fieldname] FROM [tablename] WHERE [fieldname] NOT LIKE "%[keyword]%" 

for example:

$query_OtherTeams = "SELECT DBteam, TeamName, TeamNameS FROM whatteam WHERE DBteam NOT LIKE '%Mens%' AND DBteam NOT LIKE '%Ladies%'";

[samgeorge]

Why is human knowlage better that books??