Trouble with creating MySQL query

Try the following. You may get by with removing the LOWER, but I think it may be required for string comparisons.

SELECT *
FROM tblName
WHERE LOWER(statename) BETWEEN 'air university' AND 'alabama university'

Select allOpen in new window

so you want to change "Air University" (let's say statename = 1) to "Alabama University" (statename = 2)? If so, use update:

UPDATE yourTable set statename = 2 WHERE statename = 1

i guess this should be the answer...


update  tblName set statename = 'any'
WHERE fieldname between 'brazil' and 'canada'

Well,
this didn't work:

$sql = "DELETE 
FROM universities2
WHERE BETWEEN 'Faulkner University' AND 'Stillman College'";

Select allOpen in new window

Neither did this:

$sql = "DELETE 
FROM universities2
WHERE universityID BETWEEN LIKE '%Auburn University at Montgomery%' AND LIKE '%Huntsville%'";

Select allOpen in new window

any other suggestions?

Do you want to delete the records
can you told me in which firld 'Faulkner University' these values are store there you need to give the between
if it stored in fieldname like uname then query will be


$sql = "DELETE
FROM universities2
WHERE uname BETWEEN 'Faulkner University' AND 'Stillman College'";

I want to change the column called stateID to 2.  I do not want to delete these records.

So I came up with this and it still doesn't work.  Lets see if someone can fix this:

$sql = "UPDATE universities2
SET stateID='2' WHERE unversityID BETWEEN '8' AND '14'";

Select allOpen in new window

THE man, thanks

THE man, thanks

Not according to her Eeple  ; )

my bad, sorry Pratima, nonetheless thank you.