MySql returns 0 when it sould be returning 604

[rhyno]

I have a db that will allow my users to select their country, from that they can select there state/province but it is not storing correctly in the db. it is storing 0, when it should be storing 604 for canada/ontario combo.

 

SELECT `id` FROM `list` WHERE `country` = 'Canada' AND `area` REGEXP CONVERT( _utf8 'Ontario ' USING latin1 ) COLLATE latin1_general_ci LIMIT 1

 

I am unsure if I am using the REGEXP CONVERT correctly.

php version 5 Thank you for the replies.

[revraz]

Are you missing a = after `area` ?

[rhyno]

Nope just tried that like 15 minutes ago...

SQL query: Documentation

SELECT `id`
FROM `list`
WHERE `country` = 'Canada'
AND `area` =
REGEXP CONVERT( _utf8 'Ontario '
USING latin1 )
COLLATE latin1_general_ci
LIMIT 1

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REGEXP CONVERT( _utf8 'Ontario ' USING latin1 ) COLLATE latin1_general_ci LIMIT ' at line 1