Have you considered Reading The *Fine* Manual at
http://dev.mysql.com/doc/#manual ?
On Sat, Dec 5, 2009 at 4:59 PM, Victor Subervi wrote:
> Hi;
> I remember vaguely how to do this but don't know how to google it:
>
> show tables like categories$;
>
> such that it will return tables such as:
>
>
On Sat, Dec 5, 2009 at 11:09 AM, Michael Dykman wrote:
> show tables like 'categories%';
>
Thanks.
V
Hi;
I remember vaguely how to do this but don't know how to google it:
show tables like categories$;
such that it will return tables such as:
categoriesProducts, categoriesPrescriptions, etc.
TIA,
Victor
These are the statements that are currently giving me the problems.
SELECT @main_id:=ID, @FCSecID:=FCSecID, @Periodicity:=Periodicity,
@EOP:=EOP FROM main_data_temp WHERE checked=0 ORDER BY fcsecid ASC LIMIT
1;
SELECT * FROM actuals WHERE [EMAIL PROTECTED] AND Period LIKE
'[EMAIL PROTECTED]'; # A