Monthly Archives: November 2021

SQL Scratch

These are just scratches/notes for my work with Prestashop select id_product, reference from ps_product where reference like ‘9254050’ limit 10; Uppercase first letter only on string, and lowercase the others (remove any spaces infront or at the end)select name, concat(upper(left(name,1)),lower(substring(name,2,length(name)))) … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment