SELECT in MySQL ...

fish0101

table1:
f1:
one ...
two ...
three ...
...

table2:
ff1:
oneone ...
onetwo ...
onethree ...
onefour ...
...
twoone ...
twotwo ...
twothree ...
twofour ...
...

I want get:
f1 ff1 ...
one oneone ...
one onetwo ...
two twoone ...
two twotwo ...
three threeone ...
three threetwo ...
...

How to write the SELECT?

Thanks!

vponz

Try this:

select f1, ff1 from table1, table2
where left(ff1, length(f1)) = f1

Víctor Ponz
Spain

fish0101

Sorry, My mean is want:

select ff1 contain f1

and limit the return match rows(3 times),

SELECT * FROM table1,table2 WHERE ff1 LIKE f1 LIMIT 0,12

It's get:
f1 ff1
one one
one one
one one
one one
one one
one one
one one
one one
one one
one one
one one
one one

Is not I want(=any character):
one one
one one
one one
two two
two two
two two
three three
three three
three three
four four
four four
four four*

Thanks!

sarahk

Your question is pretty confusing but review the following sql statements to see if they help

// only get records which match on the id
Select
from table1, table2
where table1.id = table2.id

// get table2 records where they match in table 1, slower but sometimes necessary
Select
from table2
where table2.id in (select table1.id from table1)

You can also prefix the with the table name if you only want all the data from a specific table eg table1., table2.id

You can rename output fields eg select table2.id as tab2id, ...

I think you need to revisit your question and look at how you ask the question as I don't think your outcome is clearly defined.

Anon

Thanks very much!

About this question part 1,

I already get it use LOCATE:
SELECT * FROM table1,table2 WHERE LOCATE(f1,ff1)

It's work ok,get a match is:
(=any char)
f1: ff1:
one one
one aone
one bone
one cone
one done
...
one one
two xtwox
two 1two
two atwo
two ccctwo
...
two two
three 1three
three 2three
three 3three
three athree
...
three three

I only want get the first sometime match(example 3 times):
(*=any char)
f1: ff1:
one one
one aone
one bone
two xtwox
two 1two
two atwo
three 1three
three 2three
three 3three

How to do it?