MySQL: Update a column if value is numeric only
3800
How do I check to see if a value is an integer in MySQL?
85307
Can I configure MySQL's typecasting to consider 0 != 'foo'?
108153
Preparing a MySQL INSERT/UPDATE statement with DEFAULT values
139291
How can I "select *" from a table in MySQL but omit certain columns?
97500
Modifying a column in a table
61724
MySQL - UPDATE multiple rows with different values in one query
101193
Auto Increment Number Based on Another Field
107822
Is it possible to decrement a variable in MySQL?
143824
MySQL update case help
145332
Does MySQL overwrite a column of same value on update?
25134
How do I perform an IF...THEN in an SQL SELECT?
103532
How do I update if exists, insert if not (AKA "upsert" or "merge") in MySQL?
87213
Summing a comma separated column in MySQL 4 (not 5)
148930
How can I modify the size of column in a MySQL table?
19756
Find and replace a portion of text in a field using MySQL
15342
Biggest possible double/float for a column in my MySQL database
119123
How to make a number field increment by one as per a certain criteria?