I'm trying to build a really basic search engine for a site I'm using -
say I'm going to simplify this as much as I can.
Say I have a table with 2 columns: id, message
Person wants to search for the term 'sql'. So, I'd do a simple search
like:
select id from tablename where message like '%sql%'
Hi everyone, I'm trying to do a left join on two tables, mainly because
data from table 'b' (lists) may or may not exist, and if it doesn't I
want results. However, if data from table lists DOES exist, I want to
run a conditional on it, and then return data based on whether the
conditional is true
