Skip to Main Content
maradydd (
maradydd
) wrote
2009
-
01
-
05
03:10 am
Today's accomplishments so far
Wrote a bunch of emails
Made a table
Did not eated it
Flat
|
Top-Level Comments Only
no subject
bunnykitteh.livejournal.com
2009-01-08 05:32 am (UTC)
(
link
)
U haz geeks in ur f'list! LOL
I'm afraid that processed junk gets returned as a match for being "like '%food%'"... how about:
select * from table
left join whole_foods_reference
on table.item_name = whole_foods_reference.item_name
where table.descriptions like "%food%"
Except this will only return basic ingredients.
Mmm this food is problematic.
7 comments
Post a new comment
Flat
|
Top-Level Comments Only
Log in
Account name:
Password:
Remember me
Other options:
Forget your password?
Log in with OpenID?
Close
menu
Log in
Create
Create Account
Display Preferences
Explore
Interests
Directory Search
Site and Journal Search
Latest Things
Random Journal
Random Community
FAQ
Shop
Buy Dreamwidth Services
Gift a Random User
DW Merchandise
Interest
Region
Site and Account
FAQ
Email
no subject
I'm afraid that processed junk gets returned as a match for being "like '%food%'"... how about:
select * from table
left join whole_foods_reference
on table.item_name = whole_foods_reference.item_name
where table.descriptions like "%food%"
Except this will only return basic ingredients.
Mmm this food is problematic.