Related Files ! Howto?

[dev2design]

I have a file uploader site in which i wanted to show related files in the file download page. Related files need to be calculated based on the " file name" only

In My file table i have two fields , file_id and file_name

eg:- 1, gods_must_be_crazy_part1.flv

5 Related files should be shown (most matching should come first)

eg-: Related files

1) gods_must_be_crazy_part2.flv
2) gods_must_be_crazy_part3.flv
3) gods_must_be_crazy_part1.wmv
4) godsmustbecrazy.mpg
5) godsarenotcrazy.jpg


Please help me how will i go about doing this in mysql/php?

[Dr John]

your problem is thatyoud on't knowwhere the words formingthefilename are in the file name, if you see what I mean. So trying to split up the name and use parts in a set of where file_name like"%part% is tricky.