PHP Lowercase chars and Sql

[Chris2k]

straght to the point:

how to say;

$find = 'select type from table'

if(table field uses lowercase chars) {
    // do this shit
}

 

[Apathetic]

function isPartUppercase($string) {
    return (bool) preg_match('/[A-Z]/', $string);
}

 

[Chris2k]

what's the

return for

cant i do:

$frind = 'select type from table where strtolower(blah) or strtolower(blah) or strtolower(blah) or strtolower(blah) or strtolower(blah) or strtolower(blah) or strtolower(blah) or strtolower(blah) or strtolower(blah)';

 

[soft2050]

Can't get you, care to explain?
If you want to select everything in lower case, then use mysql LOWER or LCASE function

 

[Chris2k]

i wanna find just the types that exist and are lowercase eg:

app, movie, tv, music, etc. << lowercase words in the type field only, ignore these:

App, Movie, TV, Music etc. << they have an uppercase letter, cos i wanna delete only lowercase words........
5

---------- Post added at 10:48 PM ---------- Previous post was at 09:11 PM ----------

just tried:

 IN ('app', 'music', 'tv', 'movie', 'template', 'ebook', 'xxx', 'mobile', 'game', 'stream')

not good, delete all lower nnn uppercase.

 

[Putin]

SQL 'LIKE' is case insensetive, you might want to try that.

 

[soft2050]

i wanna find just the types that exist and are lowercase eg:

app, movie, tv, music, etc. << lowercase words in the type field only, ignore these:

App, Movie, TV, Music etc. << they have an uppercase letter, cos i wanna delete only lowercase words........
5

---------- Post added at 10:48 PM ---------- Previous post was at 09:11 PM ----------

just tried:

 IN ('app', 'music', 'tv', 'movie', 'template', 'ebook', 'xxx', 'mobile', 'game', 'stream')

not good, delete all lower nnn uppercase.

In that case, use this to select:

$query = "SELECT * FROM table WHERE type REGEXP '^[a-z]+'";

 

[Chris2k]

that is still selecting lower n uppercase m8, sql "LIKE" is CASE insensitive ass Put9in siad.............

SELECT * FROM wcddl_queue WHERE type LIKE ('app', 'music', 'tv', 'movie', 'template', 'ebook', 'xxx', 'mobile', 'game') = n0t working.