Hi Im haveing a problem with ucwords and FINDINSET in a query I have tried all sortsof ways but just get errors
I currently have and get FUNCTION ucwords does not exist. Can anybody help please
$query = "SELECT * FROM TABLE1, TABLE2 WHERE FIND_IN_SET(ucwords(TABLE1.field), TABLE2.field)";
ucwords is a PHP function, it will not work in an SQL query. I don't think you need it, unless your database is configured to be case-sensitive.
Hi thanks for reply, yes but i cant find a query in mysql that will update the field to ucwords
do you have that option please? Itried it with this but got FUNCTION ucwords does not exist
UPDATE `TABLE` SET `field` = ucwords(`field`);
Am not sure there is one in SQL. So either you get the fields from SQL, update them in PHP and then update the database, or you need to find/write a stored procedure that does this.
WOW too complicated for me , any advice for a start?
Run the query in phpMyAdmin, then use it in your query.
ok thanks
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.