MYSQL IF ELSE

[slick101]

hey everyone,

trying to figure out doing a select statement

what i need is

select from a table where field2 is like '%t' else select field1 like '%t'

i tried few
SELECT field2 FROM table
WHERE field2 LIKE 't%'
IF field2 = '' THEN
SELECT field1 FROM table WHERE field1 LIKE 't%'

also tried

SELECT CASE field2 WHEN LIKE 't%' THEN field1 WHEN LIKE 't%' END FROM table

i guess i have syntax wrong anyone havea clue?

[heffym]

IF search_condition THEN statement_list
[ELSEIF search_condition THEN statement_list] ...
[ELSE statement_list]
END IF

The search condition is your select statement hope this helps.